Executive Summary and the problems that occurred during the project 3

Executive Summary


Problems that occurred during the project

1. Size of the Data: The Data contained 4.2 million records, 49 columns and a size of 1.5 MB. This makes the transformation process a slower than previous projects. It takes an average of 2-3 minutes to get the data updated after any transformation occurs.

2. Creating the right measures: Due to the number of records in the data, extra thought and consideration was put into creating the right measures that is able present the data in a way that it is easily relatable. For example, taking the high figures of the total accidents that occurred, and breaking it down to accident per day.

3. Relevant Data Dimensions: The complexity of the data created a problem of how the find the right dimensions that can be relevant to the data. For example, severity as a column had to be classified into Low, Average and High Severity respectively for better analytics.



Link below sheds more light on some of the limitations of Power BI.

https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-limitations